Title: Year 12 / Computer Science / Theory / 8 - Databases / 8.2 - Database Management System (DBMS)

Q: Name 2 software tools found within a DBMS
A: developer interface and query processor

Q: Explain how the developer interface in a DBMS is used in practice
A: allows creating and manipulating of database in SQL instead of graphically

Q: Explain how the query processor in a DBMS is used in practice
A: handles high level queries, parses, validates, optimises and compiles or interprets a query which results in the query plan

Q: Name 6 features that a DBMS provides that addresses the limitations of a file based approach
A: data management, data dictionary, data modeling, logical schema, data integrity, data security

Q: State what is meant by a DBMS
A: software program that allows databases to be defined, constructed and manipulated

Q: Explain the "data management" feature of a DBMS
A: data gets stored in relational databases, whose tables are stored in secondary storage

Q: Explain the "data dictionary" feature of a DBMS
A: contains list of all files in database, number of records in each file, names and types of each field

Q: Explain the "data modeling" feature of a DBMS
A: does analysis of data objects used in database, identifies relationships among them

Q: Explain the "logical schema" feature of a DBMS
A: its an overall view of entire database and includes entities, attributes and relationships

Q: Explain the "data integrity" feature of a DBMS
A: entire block gets copied to users area when being changed, then saved back when done

Q: Explain the "data security" feature of a DBMS
A: handles password allocation and verification, backups database automatically, controls what certains users view by access rights of individuals or group of users